Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CompetitorID (PK) | The unique identifier assigned to a competitor by the store. | ID_CMP | Identity | integer | |
OpenDate | The date the competitor opened. | DC_OPN_CMP | DateCalendar | date | |
CloseDate | The date the date the competitor closed | DE_CL_CMP | DateCalendar | date | |
StatusCode | The current status of the competitor. | SC_CMP | Code2Status | char(2) | |
PartyRoleAssignmentID (FK) | Token identifier for a PartyRoleAssignmentInstance. | ID_PRTY_RO_ASGMT | Identity | integer | PartyRoleAssignment(PA_RO_PRTY) |